Skip to main content

GCD

Returns the greatest common divisor of one or more integers.

Sample Usage​

GCD(A2:A5)

GCD(24,96,A4)

Syntax​

GCD(value1, [value2, ...])

  • value1 - The first value or range whose factors to consider in a calculation to find the greatest common divisor.
  • value2, ... - [ OPTIONAL ] - Additional values or ranges whose factors to consider to find the greatest common divisor.

Notes​

  • Any input with a decimal part provided to GCD will be silently truncated.

See Also​

LCM: Returns the least common multiple of one or more integers.

Examples​